package com.lq.educationsystem.lqclasses.mapper;

import com.lq.educationsystem.lqclasses.entiy.ClassesSubjectTb;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author Administrator
* @description 针对表【classes_subject_tb】的数据库操作Mapper
* @createDate 2024-05-03 11:00:46
* @Entity com.lq.educationsystem.lqclasses.entiy.ClassesSubjectTb
*/
public interface ClassesSubjectTbMapper {

    int deleteByPrimaryKey(Long id);

    int insert(ClassesSubjectTb record);

    int insertSelective(ClassesSubjectTb record);

    ClassesSubjectTb selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(ClassesSubjectTb record);

    int updateByPrimaryKey(ClassesSubjectTb record);

    /**
     * 列表查询
     * @param start
     * @param pageSize
     * @param classesSubjectTb
     * @return
     */
    List<ClassesSubjectTb> queryList(@Param("start") int start,@Param("pageSize") Integer pageSize,@Param("classesSubjectTb") ClassesSubjectTb classesSubjectTb);

    int queryInfoCount(@Param("classesSubjectTb") ClassesSubjectTb classesSubjectTb);

    List<ClassesSubjectTb> querySubjectInfoListByClassesId(@Param("classesSubjectTb") ClassesSubjectTb classesSubjectTb, @Param("start") int start,@Param("pageSize") Integer pageSize);

    List<ClassesSubjectTb> queryClassesSubjectInfoByTeacherSubjectId(@Param("teacherSubjectIdList") List<Integer> teacherSubjectIdList);
}
